Kolumna OrgUnitID tabeli OrgUnit

Definicja kolumny OrgUnitID tabeli OrgUnit

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID jednostki organizacyjnej


Kolumna OrgUnitKindID tabeli OrgUnit

Definicja kolumny OrgUnitKindID tabeli OrgUnit

Name

OrgUnitKindID

Code

OrgUnitKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrgUnitTypeID tabeli OrgUnit

Definicja kolumny OrgUnitTypeID tabeli OrgUnit

Name

OrgUnitTypeID

Code

OrgUnitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrgUnitFunctionMHID tabeli OrgUnit

Definicja kolumny OrgUnitFunctionMHID tabeli OrgUnit

Name

OrgUnitFunctionMHID

Code

OrgUnitFunctionMHID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyTypeID tabeli OrgUnit

Definicja kolumny HierarchyTypeID tabeli OrgUnit

Name

HierarchyTypeID

Code

HierarchyTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostTypeID tabeli OrgUnit

Definicja kolumny CostTypeID tabeli OrgUnit

Name

CostTypeID

Code

CostTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContactTypeID tabeli OrgUnit

Definicja kolumny ContactTypeID tabeli OrgUnit

Name

ContactTypeID

Code

ContactTypeID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna FounderBodyID tabeli OrgUnit

Definicja kolumny FounderBodyID tabeli OrgUnit

Name

FounderBodyID

Code

FounderBodyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PlaceID tabeli OrgUnit

Definicja kolumny PlaceID tabeli OrgUnit

Name

PlaceID

Code

PlaceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Org_OrgUnitID tabeli OrgUnit

Definicja kolumny Org_OrgUnitID tabeli OrgUnit

Name

Org_OrgUnitID

Code

Org_OrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli OrgUnit

Definicja kolumny CostAccountID tabeli OrgUnit

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DefaultSellerID tabeli OrgUnit

Definicja kolumny DefaultSellerID tabeli OrgUnit

Name

DefaultSellerID

Code

DefaultSellerID

Data Type

NUMBER(10)

Mandatory

No

Comment

Sprzedawca przypisany do stanowiska kasowego. Pole uzupelniane tylko dla stanowisk kasowych (orgUnit o hierarchyTypeId = 200).


Kolumna Code tabeli OrgUnit

Definicja kolumny Code tabeli OrgUnit

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna InterfaceCd tabeli OrgUnit

Definicja kolumny InterfaceCd tabeli OrgUnit

Name

InterfaceCd

Code

InterfaceCd

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna ShortName tabeli OrgUnit

Definicja kolumny ShortName tabeli OrgUnit

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli OrgUnit

Definicja kolumny FullName tabeli OrgUnit

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli OrgUnit

Definicja kolumny Description tabeli OrgUnit

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Accounting tabeli OrgUnit

Definicja kolumny Accounting tabeli OrgUnit

Name

Accounting

Code

Accounting

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Active tabeli OrgUnit

Definicja kolumny Active tabeli OrgUnit

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna CompanyStatisticalNo tabeli OrgUnit

Definicja kolumny CompanyStatisticalNo tabeli OrgUnit

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

REGON


Kolumna TaxPayerID tabeli OrgUnit

Definicja kolumny TaxPayerID tabeli OrgUnit

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna Manager tabeli OrgUnit

Definicja kolumny Manager tabeli OrgUnit

Name

Manager

Code

Manager

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna StartDT tabeli OrgUnit

Definicja kolumny StartDT tabeli OrgUnit

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli OrgUnit

Definicja kolumny StopDT tabeli OrgUnit

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna UnitNo tabeli OrgUnit

Definicja kolumny UnitNo tabeli OrgUnit

Name

UnitNo

Code

UnitNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StatCode tabeli OrgUnit

Definicja kolumny StatCode tabeli OrgUnit

Name

StatCode

Code

StatCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kod resortowy


Kolumna Servicer tabeli OrgUnit

Definicja kolumny Servicer tabeli OrgUnit

Name

Servicer

Code

Servicer

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BankAccount tabeli OrgUnit

Definicja kolumny BankAccount tabeli OrgUnit

Name

BankAccount

Code

BankAccount

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna CustomerContractNo tabeli OrgUnit

Definicja kolumny CustomerContractNo tabeli OrgUnit

Name

CustomerContractNo

Code

CustomerContractNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna IgnoreHISstats tabeli OrgUnit

Definicja kolumny IgnoreHISstats tabeli OrgUnit

Name

IgnoreHISstats

Code

IgnoreHISstats

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna CostStatus tabeli OrgUnit

Definicja kolumny CostStatus tabeli OrgUnit

Name

CostStatus

Code

CostStatus

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CallCentreEnabled tabeli OrgUnit

Definicja kolumny CallCentreEnabled tabeli OrgUnit

Name

CallCentreEnabled

Code

CallCentreEnabled

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Comments tabeli OrgUnit

Definicja kolumny Comments tabeli OrgUnit

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna IdentificationNo tabeli OrgUnit

Definicja kolumny IdentificationNo tabeli OrgUnit

Name

IdentificationNo

Code

IdentificationNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

 


Kolumna HealthCareName tabeli OrgUnit

Definicja kolumny HealthCareName tabeli OrgUnit

Name

HealthCareName

Code

HealthCareName

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna HealthCareNameResort tabeli OrgUnit

Definicja kolumny HealthCareNameResort tabeli OrgUnit

Name

HealthCareNameResort

Code

HealthCareNameResort

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna OPK tabeli OrgUnit

Definicja kolumny OPK tabeli OrgUnit

Name

OPK

Code

OPK

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna WorkingHours tabeli OrgUnit

Definicja kolumny WorkingHours tabeli OrgUnit

Name

WorkingHours

Code

WorkingHours

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna ServiceScope tabeli OrgUnit

Definicja kolumny ServiceScope tabeli OrgUnit

Name

ServiceScope

Code

ServiceScope

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna TransferCost tabeli OrgUnit

Definicja kolumny TransferCost tabeli OrgUnit

Name

TransferCost

Code

TransferCost

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SplitByDC tabeli OrgUnit

Definicja kolumny SplitByDC tabeli OrgUnit

Name

SplitByDC

Code

SplitByDC

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna StatCode1stPart tabeli OrgUnit

Definicja kolumny StatCode1stPart tabeli OrgUnit

Name

StatCode1stPart

Code

StatCode1stPart

Data Type

VARCHAR2(12)

Mandatory

No

Comment

I czesc kodu resortowego, numer ksiegi rejestrowej


Kolumna StatCode5thPar tabeli OrgUnit

Definicja kolumny StatCode5thPar tabeli OrgUnit

Name

StatCode5thPar

Code

StatCode5thPar

Data Type

VARCHAR2(3)

Mandatory

No

Comment

V czesc kodu resortowego, identyfikator jednostki org.


Kolumna StatCode6thPart tabeli OrgUnit

Definicja kolumny StatCode6thPart tabeli OrgUnit

Name

StatCode6thPart

Code

StatCode6thPart

Data Type

VARCHAR2(1)

Mandatory

No

Comment

VI czesc kodu resortowego


Kolumna StatCode7thPart tabeli OrgUnit

Definicja kolumny StatCode7thPart tabeli OrgUnit

Name

StatCode7thPart

Code

StatCode7thPart

Data Type

VARCHAR2(4)

Mandatory

No

Comment

VII czesc kodu resortowego, identyfikator komórki org.


Kolumna StatCode8thPart tabeli OrgUnit

Definicja kolumny StatCode8thPart tabeli OrgUnit

Name

StatCode8thPart

Code

StatCode8thPart

Data Type

VARCHAR2(4)

Mandatory

No

Comment

VIII czesc kodu resortowego, specjalnosc komórki org.


Kolumna NotMedical tabeli OrgUnit

Definicja kolumny NotMedical tabeli OrgUnit

Name

NotMedical

Code

NotMedical

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga informujaca czy jednostka organizacyjna jest medyczna czy nie.


Kolumna NoDirectAdmission tabeli OrgUnit

Definicja kolumny NoDirectAdmission tabeli OrgUnit

Name

NoDirectAdmission

Code

NoDirectAdmission

Data Type

NUMBER(10)

Mandatory

No

Comment

Zakaz bezposredniego przyjecia na dany Orgunit


Kolumna PatientSexRestriction tabeli OrgUnit

Definicja kolumny PatientSexRestriction tabeli OrgUnit

Name

PatientSexRestriction

Code

PatientSexRestriction

Data Type

NUMBER(10)

Mandatory

No

Comment

Restrykcja na dozwolona plec pacjenta w jednostce organizacyjnej. Wartosci zgodne z pozycjami w tabeli DictionaryValue dla slownika DictionaryID = -79.

DictionaryValueID, Description
-87 M - meski
-88 F - zenski
-89 D - dynamiczny - pierwszy przyjety pacjent determinuje restrykcje


Kolumna OwnRegisterBook tabeli OrgUnit

Definicja kolumny OwnRegisterBook tabeli OrgUnit

Name

OwnRegisterBook

Code

OwnRegisterBook

Data Type

NUMBER(1)

Mandatory

No

Comment

Flaga informujaca o tym, czy dla jednostki mozna wprowadzic dane ksiegi rejestrowej niezaleznie od jednostek nadrzednych.


Kolumna StatCode9thPart tabeli OrgUnit

Definicja kolumny StatCode9thPart tabeli OrgUnit

Name

StatCode9thPart

Code

StatCode9thPart

Data Type

VARCHAR2(150)

Mandatory

No

Comment

9-ta czesc kodu resortowego, podzial jedn. org. wg. FUNKCJI OCHRONY ZDROWIA


Kolumna StatCode3rdPart tabeli OrgUnit

Definicja kolumny StatCode3rdPart tabeli OrgUnit

Name

StatCode3rdPart

Code

StatCode3rdPart

Data Type

VARCHAR2(2)

Mandatory

No

Comment

III czesc kodu resortowego, 2-znakowy kod podmiotu tworzacego


Kolumna StatCode4thPart tabeli OrgUnit

Definicja kolumny StatCode4thPart tabeli OrgUnit

Name

StatCode4thPart

Code

StatCode4thPart

Data Type

VARCHAR2(4)

Mandatory

No

Comment

IV czesc kodu resortowego, 4-znakowy kod okreslajacy forme organizacyjno-prawna podmiotu wykonujacego dzialalnosc lecznicza


Kolumna Attribute_54 tabeli OrgUnit

Definicja kolumny Attribute_54 tabeli OrgUnit

Name

Attribute_54

Code

Attribute_54

Data Type

<Undefined>

Mandatory

No

Comment

 


Kolumna Attribute_55 tabeli OrgUnit

Definicja kolumny Attribute_55 tabeli OrgUnit

Name

Attribute_55

Code

Attribute_55

Data Type

<Undefined>

Mandatory

No

Comment

 


Lista kluczy tabeli OrgUnit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OrgUnit

Definicja klucza Identifier_1 tabeli OrgUnit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment